Create Summary Dashboard Visualization Part Two 12
Create Questions &
First Response Time Visualization (Last 12 Weeks)
·
Select Line and Clustered Column Chart
·
For the Shared Axis Field For the Week Hierarchy, For the
week and DayofWeek
·
For Column values Field Drag and Drop Answer Needed
Qns per day
· For Line values Field Drag and Drop First Response Hrs and Response HR Goal
·
Go to The Filters click on For the Week
-
Select Top N
-
Show Items Top 12
-
Drag and drop on by value Weekend from the date table
Formatting
·
General
-
X- position 1272
-
Y- position 456
-
Width 1228
-
Hight 456
·
Legend
-
Color Black
-
Font Family Segoe (Bold)
-
Text Size 16
·
X-Axis
-
Color-------------- Black
-
Text Size ----------15
-
Title Color --------Black
-
Title Size---------- 16
·
Y-Axis
-
Color --------#F1C40F
-
Text ----------16
-
Show Secondary ---On
-
Align Zeros --------On
-
Scaler type -------- Liner
-
Color --------------Black
-
Text ----------------16
·
Data Color
-
First Response Hrs -----#34495E
- Response HR Goal------#A0D1FF
·
Data Lab
-
Color -------Black
-
Text Size -----16
-
Show Background ----ON
-
Background Color ----White
-
Custom Size --------ON
Answer Needed Qns Per Day
-
Show -----ON
-
Color ------#F1C40F
-
Text -------16
-
Show Background ---ON
-
Background Color ----31%
·
Shapes
-
Shade area
------ON
-
Width ------- 4
·
Title
-
Title text
. Click Fx
-
Font Color --------#F1C40F
-
Background Color-----#34495E
-
Alignment -------Center
-
Text --------25
·
Background
-
Color ---------White
-
Transparency -------15%
·
Border --------ON
-
Color ------Black
·
Shadow -------------ON
-
Color -------Black
· Tooltip ---------ON
Create Post &
Rolling Month Change (Last 12 Weeks)
·
Select Line and Clustered Column Chart
·
For the Shared Axis Field For the Week Hierarchy, For the
week and DayofWeek
·
For Column values Field Drag and Drop Total Posts per
day
· For Line values Field Drag and Drop Rolling Month % Change